//
//  lxSql.h
//  luodansc
//
//  Created by 倫 星 on 2012/10/20.
//  Copyright (c) 2012年 方正株式会社. All rights reserved.
//

#ifndef luodansc_lxSql_h
#define luodansc_lxSql_h

#define selectAppInfo @"select name, version from APP_INFO"
#define insertAppInfo @"insert or replace into APP_INFO(name, version) values(%@)"
#define delAppInfo @"delete from APP_INFO"

#define selectUserInfo @"select user_id, email, user_name, password, question, answer, sex, birthday, user_money, frozen_money, pay_points, rank_points, address_id, reg_time, last_login, last_time, last_ip, visit_count, user_rank, is_special, salt, parent_id, flag, alias, msn, qq, office_phone, home_phone, mobile_phone, is_validated, credit_line, passwd_question, passwd_answer, user_bonus from USER_INFO"
#define insertUserInfo @"insert or replace into USER_INFO(user_id, email, user_name, password, question, answer, sex, birthday, user_money, frozen_money, pay_points, rank_points, address_id, reg_time, last_login, last_time, last_ip, visit_count, user_rank, is_special, salt, parent_id, flag, alias, msn, qq, office_phone, home_phone, mobile_phone, is_validated, credit_line, passwd_question, passwd_answer, user_bonus) values(%@)"
#define delUserInfo @"delete from USER_INFO"

#endif
